Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
I'm completely new to the world of joins in mysql and I would like to know if this syntax *hypothetically* would be correct:-
SELECT `column_name1`, `column_name2` FROM `table_name1` FULL JOIN `table_name2` ON `table_name1.column_name1`, `column_name2=table_name2.column_name` WHERE `column_name` = 'cell_data' LIMIT 1
Could anyone advise me as to whether I am indeed in the right area with this, again it hypothetical at this point, but will be used once I have the theory nailed.
will match EXACTLY with 1 piece of data