Joing data from three tables
Posted: Mon Apr 19, 2004 9:32 am
i have three tables
ocda_images_gd
ocda_images_ra
ocda_images_wd
the three tables have EXACTLY the same structure
I want to select the data from all 3 tables and display the information. The data from the tables is not related in anyway.
What query do i need to use?
Thanks
Mark
ocda_images_gd
ocda_images_ra
ocda_images_wd
the three tables have EXACTLY the same structure
Code: Select all
Field Type Null Key Default Extra Privileges
--------- ------------ ------ ------ ------- -------------- -------------------------------
id int(3) PRI (NULL) auto_increment select,insert,update,references
path varchar(255) YES (NULL) select,insert,update,references
caption varchar(255) YES (NULL) select,insert,update,references
weighting char(3) YES (NULL) select,insert,update,references
main_pic char(1) YES (NULL) select,insert,update,references
active char(1) YES (NULL) select,insert,update,referencesWhat query do i need to use?
Thanks
Mark