Using Lasso 8.5 and MySQL.

I have a 4 table join which works.

The problem is for 2 of the tables I need to see the join EVEN if there isn't a match.

So I'm joining tables A, B, C, and D and also doing a WHERE table C has xxx value.

BUT what I also need (in a separate query) is to do a join of A, B, C, and D and see records across all 4 tables even when there is no match between A and B.

I need to see every A record and IF there's a match see the matching B record and if not see the fields for B with 'null' values; in that same query I need to join the B records with C and C with D. And do a WHERE D = somevalue.

No matter what I try I keep getting ONLY the A records that have matching B records. I can't get ALL A records.

Any ideas?

Thanks in advance.




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's better to burn out than to fade away."

Tami Williams
Creative Computing
Let us help you make frustrating, costly, and inefficient processes more efficient, less costly and scalable.
Lasso, MySQL and FileMaker specialists.

Tel/Fax: 770.457.3221
E-Mail: info@asktami.com
Web: http://www.asktami.com/
LinkedIn: http://www.linkedin.com/in/asktami
Twitter: http://twitter.com/asktami
iChat/AIM/Skype: tamiwilliamsusa

FileMaker Solutions Alliance Associate | Lasso Professional Alliance Member | Certified Lasso Developer | FileMaker 11 Certified Developer

------

If you want to receive sporadic email from Creative Computing regarding news at the company and announcements about upcoming Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>