Hi,I have 2 tables: create table resources ( res_id int identity primary key, res_name varchar(50) not null unique, res_url varchar(200) <more fields>...);create table resource_names ( res_id int not null, res_name varchar(50) not null, primary key (res_id, res_name), foreign key (res_name) references resources (res_id));
The reason why I have the 'resource_names' table is because there are some resources which may have alternative names and I don't want to keep them in the main 'resources' table. My question is, how can I pull up all resources from both tables so that the returning results will look like this:res_id res_name res_url====== ======== =======1 A1 http://res1_url.com1 A2 http://res1_url.com1 A3 http://res1_url.com2 B1 http://res2_url.com3 C1 http://res3_url.com
I need only the first resource with specific res_id to be from 'resources' table (res_id 1 in example above), the rest (with with same res_id) should be from 'resource_names', and all other fields from 'resources' should show on all records.Thanks in advance,VG
Need help with easy query
Posted - 2006-08-17 : 18:13:22
