MySQL Forums
Forum List  »  Newbie

Re: MySQL Join 4 Tables
Posted by: Phillip Ward
Date: February 06, 2023 08:16AM

If there are no matching records in tables C or D then you should still get the data from tables A and B, because I used 'left join's, which allow for this.

Enough with the Guesswork. As I have asked you before:

Please try posting:
- Create Table statements for the tables involved,
- Insert statements with [just] enough data to reproduce the problem, and (most importantly)
- Your desired output.

Regards, Phill W.

Options: ReplyQuote

Written By
January 29, 2023 11:48PM
January 30, 2023 07:25AM
January 31, 2023 08:26AM
January 31, 2023 10:36AM
February 01, 2023 07:23AM
February 02, 2023 12:17AM
Re: MySQL Join 4 Tables
February 06, 2023 08:16AM

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.