NVM guys. I've solved my problems. It's Borland C++ DBGrid's problem. Not my query problem.

Thanks for all the help! ^_^

Yes, you are correct. My ProcLoc table is used to overcome the M to M relationship between Product and Location. My Test table however, is used to hold test datas,...

Thanks. This also works if I use in my SQL query browser.

I am using Borland Database library to display these data and I am using DBGrid. However, I get (MEMO)...

Thanks a lot. I got this correct.

SELECT test.TestID, IFNULL(location.LocationName, '-'), IFNULL(product.ProductName, '-')

FROM Test as test

INNER JOIN ProdLoc AS ProdLoc ON test.ProdLocID = prodLoc.ProdLocID

LEFT JOIN Product AS product ON ProdLoc.ProductID...

Thanks a lot. I got this correct.

SELECT test.TestID, IFNULL(location.LocationName, '-'), IFNULL(product.ProductName, '-')

FROM Test as test

INNER JOIN ProdLoc AS ProdLoc ON test.ProdLocID = prodLoc.ProdLocID

LEFT JOIN Product AS product ON ProdLoc.ProductID...

My same data and query are as follows:

ProdLoc Table

---------

ProdLocID, ProductID, LocationID

1, -, 23

2,112, 24

3, 115, 24

Product Table

------------

ProductID, ProductName

112, ABC

115, DEF

Location Table

-------------

LocationID, LocationName

22, HumanResource

23, Engineering

24, Marketing

Test Table

---------

TestID, ProdLocID

31, 1

32, 2

33, 3

SELECT...

Okay.

I am grabbing the IDs from my C++ application.

Anyways, thanks guys. I will try the solutions and see how it goes.