MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: MSSQL to MySQL
Posted by: Bill Karwin
Date: April 06, 2006 12:18PM

Each of those subqueries is really a join against various columns from the Items table. You've already taken care of the relationship between OfferResponses and Items, so you should just be able to join (for instance) Categories.RecordID = Items.CategoryID.

Regards,
Bill K.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MSSQL to MySQL
Kadesh Bailey
April 05, 2006 06:33AM
Re: MSSQL to MySQL
Vlatko Šurlan
April 05, 2006 07:02AM
Re: MSSQL to MySQL
Claude Martin
April 05, 2006 08:27AM
Re: MSSQL to MySQL
Bill Karwin
April 05, 2006 11:05AM
Re: MSSQL to MySQL
Kadesh Bailey
April 05, 2006 02:28PM
Re: MSSQL to MySQL
Kadesh Bailey
April 05, 2006 11:26PM
Re: MSSQL to MySQL
Bill Karwin
April 06, 2006 12:18PM
Re: MSSQL to MySQL
Kadesh Bailey
April 06, 2006 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.