Mysql inner join problem

[Anonymous]

Hi, I am trying to use Inner Join to join two tables.
My first table name Ni
CustomerID
OrderID

My second table name Be
OrderID
BusinessID
BusinessName
BusinessAddress

I tried this SQL but it didn't work.....Anyone have any comment !!

"Select Ni.CustomerID,Ni.OrderID from Ni Inner Join Be on Ni.OrderID=Be.OrderID where Ni.CustomerID =$CustomerID ";

 

[Anonymous]

Select Ni.CustomerID,Ni.OrderID 
from Ni , Be 
where Ni.OrderID=Be.OrderID 
and Ni.CustomerID =$CustomerID

this should work