2 tables problem

[shakran]

Hi,
here's the problem

I'm making a website in ASP.NET (and using SQL for my databases) I have 2 tables -> Tabel_company(company_id, company_name,experience_type,company_region) & Tabel_experience(id_exp, username,experiences,company_id)
i would like something like this:

name type region
------------------------------
IBM interview san diego
username experience
------------------------
mark01 "boss is friendly"
james91 "didnt offer coffee"

Apple internship california
username experience
------------------------
johnson91 "cool place to work"

so far i have:
INSERT INTO table_experience VALUES (@experiences,@username) WHERE table_company.company_id = table_experience.company_id

any idea's?

 

[r937]

INSERT VALUES WHERE is wrong

it's either INSERT VALUES or INSERT SELECT WHERE

r937.com | rudy.ca