Help with SQL?

[Turbanator]

i think this is actually really straight forward and simple, but lets see

Code: Select all

SELECT 
	page_id, 
	page_name, 
	file_name, 
	access_desc, 
	is_tab, 
	is_admin
FROM 	dbo.pages 
INNER JOIN dbo.access_levels ON pages.access_level=access_levels.access_level


UPDATE 	dbo.pages
SET 	page_name=@page_name,
	file_name=@file_name,
	is_tab=@is_tab,
	is_admin=@is_admin

Above i have my select query and an incomplete update query. Incomplete because I need to update page.access_level but I'm only providing access_levels.access_desc (reverse that of the select query).

So two tables, pages and access_levels. access_level is primary key in access_levels and foreign key in pages. how do I update when i only have @access_desc?

[dmmh]

maybe I am way of and misunderstanding you but why not do it like this?

Code: Select all

SELECT
   page_id,
   page_name,
   file_name,
   access_desc,
   access_level,
   is_tab,
   is_admin
FROM    dbo.pages
INNER JOIN dbo.access_levels ON pages.access_level=access_levels.access_level


UPDATE    dbo.pages
SET    page_name=@page_name,
   file_name=@file_name,
   is_tab=@is_tab,
   is_admin=@is_admin
   access_level=@access_level