Relationships::UNION
Posted: Fri Aug 19, 2011 11:05 am
Hope you're ready for a wonderful weekend!!
Tried something today: I set the following as a relationship of the clients table.. it wasn't happy:) any thoughts?
I may try setting it up as a view instead... Thanks again! and I hope you do have a great weekend!! -Baer
__sql__ = "SELECT * FROM `transaction` WHERE ClientsID= '$ClientsID' UNION SELECT * FROM `transHistory` WHERE ClientsID= '$ClientsID'"
Tried something today: I set the following as a relationship of the clients table.. it wasn't happy:) any thoughts?
I may try setting it up as a view instead... Thanks again! and I hope you do have a great weekend!! -Baer
__sql__ = "SELECT * FROM `transaction` WHERE ClientsID= '$ClientsID' UNION SELECT * FROM `transHistory` WHERE ClientsID= '$ClientsID'"