Hi I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union But one problem when trying to join tables is that UNION works only for SELECT queries with same number of coulmns. Is there any way to join 3 or more tables having different columns using UNION? I am writing my query during the runtime. Since the user can select any number of fileds from a particular table and also I am using LEFT JOIN, I can't make all the tables having same number of fields.
Thanks for any help ------------------------------------------------------------------------------ Hi I would like to have a SQL query to couple all the five tables to accomplish my need. This is a search page and the user will be searching using the don_id Presently I am using a simple equi join which works fine if all the five tables contain data for user_id But if any of the tables have no value for that particular don_id, it is obvious that nothing is being displayed. I think that a left join will be better but can't get one to display results from all the five tables But since the don_id is not unique in the claim table, I don't know how to display this Also since the claim table can have same don_id any number of times, I would like to display all the claim details for that particular don_id Note: Also I may include more tables in the future.I am writing the sql query during the runtime by getting values from the user input and so I would prefer to have a single query to do this. 1.CREATE TABLE don(don_id char(20) primary key , buy_date date not null) ; 2.CREATE TABLE enduser( user_id char(20) primary key, user_name varchar(50) not null, user_addr_str varchar(150), don_id char(20) unique not null, pro_pd char(20) unique not null, maker varchar(150), cpu varchar(150)) ; 3.CREATE TABLE usersale(user_sale_id varchar(20) primary key, user_id varchar(20) not null, don_id varchar(20) unique not null, pro_pd varchar(16) unique not null) ; 4.CREATE TABLE ssale(shit_sale_id varchar(20) primary key, s_id varchar(20) not null, don_id varchar(20) unique not null , pro_pd varchar(16) unique not null); 5.CREATE TABLE claim(claim_id int auto_increment primary key, user_id varchar(20) not null, don_id varchar(20) not null, pro_pd varchar(20) not null, claim_date date not null, claim_det text not null) ; ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
