Apparently I just needed a good night's sleep:
select [rdb-production].[dbo].items.item_id, [rdb-production].[dbo].items.title,
[jewel-dev].[dbo].JMU_List_Items.JMU_Lists_Items_ID
FROM [rdb-production].[dbo].Items, [jewel-dev].[dbo].JMU_List_Items
WHERE ([rdb-production].[dbo].Items.Item_ID = [jewel-dev].dbo].JMU_List_Items.Item_ID) AND
([jewel-dev].[dbo].JMU_List_Items.JMU_Lists_ID = 38)
[jewel-dev].[dbo].JMU_List_Items.JMU_Lists_Items_ID
FROM [rdb-production].[dbo].Items, [jewel-dev].[dbo].JMU_List_Items
WHERE ([rdb-production].[dbo].Items.Item_ID = [jewel-dev].dbo].JMU_List_Items.Item_ID) AND
([jewel-dev].[dbo].JMU_List_Items.JMU_Lists_ID = 38)
No comments:
Post a Comment