December 4, 2006 at 2:02 pm
Select tblSales.FruitID,tblSales.Date,tblSales.Volume, tblSales.Price,
TblFruit.FruitDescription from TblFruit INNER JOIN tblSales on TblFruit.FruitID = tblSales.FruitID where tblSales.date like ‘2001*’ and tblSales.FruitID in (‘4’,’5’,’7’);
also any alternative way of selecting same results with date in 2001 !!
December 4, 2006 at 2:04 pm
Please do not cross-post, we monitor all boards.
Finish the thread here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=327570
Please consider this thread closed.
December 4, 2006 at 4:43 pm
But just to add....
FYI - this poster had this to say in another thread:
im oracle dba and applied for sql dba job and been given sql db questions, to answer and post it back havent got time to go through books and stuff, just quick, simple answer will do.
never used sql db lol
In other words, they've applied for a job they aren't qualified for and want everyone else to give them the answers for the interview.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply