How do I add minutes to a time data type?
This question has spontaneously devolved into an edit war. The author feels slighted. Here is his "closing volley" and then my ruling as a moderator (hey, I'm just cleaning up stuff).
Final notes:
It is my right, as the person who asked the que...
hope the title is good enough to freeze the reader, the pseudo code is below
"SELECT DISTINCT TO_NCHAR(ID)
, DATE
, OPEN_DATE
, NUMBER
, X
, PRODUCT
, DESCRIPTION
, D4
, TO_NCHAR(CUSTOMERNAME)
FROM CASE
I...
This query would solve your problem :
select a.Day, a.PantsColorID, b.Color as 'PantsColor', a.ShirtColorID, c.Color as 'ShortColor'
from TableClothes a
join TableColor b on b.ColorID = a.PantsColorID, TableColor c
where c.ColorID = a.ShirtColorID;
You can use a standard ANSI join first, then...
You need to join the Clothes table to the Color table twice. Like
select * from TableClothes L, TableColor C1, TableColor C2 where
L.shirtcolorid = c1.colorid and L.pantscolorid = c2.colorid
Alright I didn't want to answer this one since it's a relatively simple question and I thought a good answer would just pop up but instead we are going to take this as an intro to SQL and I'll try to both show and explain what you're doing wrong here.
First off. You're using the old style joins ...
