JOIN Problems with SQL Server -

JOIN Problems with SQL Server -

i have table (user_page_cells) displayed next query:

select tag_id, nid user_page_cells nid = 1;

it gives me results:

i have table (graph_tags):

select * graph_tags page_node = 1

which gives me results:

.

user_page_cells.nid , graph_tags.page_node both reference page nodes.

i need query display first query results

(select tag_id, nid user_page_cells nid = 1;)

with 1 column. column needs have default_graph_tag_id sec table (graph_tags) if nid = page_node or null @ if doesn't.

i have tried using left, right, full outer join cannot results looking for.

here illustration of query thought work.

select user_page_cells.tag_id, graph_tags.default_graph_tag_id user_page_cells left outer bring together graph_tags on user_page_cells.nid = graph_tags.page_node user_page_cells.nid = 1.

i no matter if left, right, or full used;

can point me in right direction?

thank you

you need include tag_id in join, if understand want.

select user_page_cells.tag_id, graph_tags.default_graph_tag_id user_page_cells left outer bring together graph_tags on user_page_cells.nid = graph_tags.page_node , user_page_cells.tag_id=graph_tags.tag_id user_page_cells.nid = 1

sql sql-server join outer-join