hello
I have three tables in data base
Table1 : Product
{
productId ( Primary Key )
productImage
}
Table2 :ProductLoc //This table don't have primary key
{
culture_id
Productid foreignkey
ProductName
}
Table3 : Orders
{
orderid PrimaryKey
name
mobile
productid foreignkey
}
I want To select this item
Name,Mobile ------------From Orders
Product Name ------------From ProductLoc
I try this code but Error Occured
select Name,Mobile,ProductName
From Orders ,ProductLoc
Where Orders.id=ProductLoc.ProductId
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Orders'.
Please Help Me