MySQL Forums
Forum List  »  General

Re: cross joining 3 tables
Posted by: Dimitris Papageorgiou
Date: September 16, 2015 05:21AM

>
> As such if user table has one row and business
> users another...the result of the above query must
> be 2 rows.

well there may be case that rows from the users table need no to show..so that above statement does describe accurately what I want to achieve.

The users table holds stores both regular users and business users...I am concerned for the business users here..that is the reason for the join anyway with bus_user_type table.

Options: ReplyQuote


Subject
Written By
Posted
September 07, 2015 07:37AM
September 07, 2015 12:20PM
September 16, 2015 10:55AM
Re: cross joining 3 tables
September 16, 2015 05:21AM


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.