Developer Forum [ All Topics | New Topic ]

Thread: Diamond Queries...

Hello, Currently I have a set of diamond inventory in a DB... I uploaded the Rap prices into a round table and a fancy(pear) table. Does anyone have a query where it joins 2 tables to calculate the pricing? Or maybe there is a better way in dong this? Thanks William

>> add a comment
11/19/2009 12:20

1 Replies:

RE: Diamond Queries...
If you want to write a join query efficiently (without many 'case' statements), you will have to make sure that you have the same fields in your diamonds table: minsize, maxsize, shape, color, clarity. It may work better if you update the Rap Prices in your diamond table after you download them. That way efficiency isn't all that important. If you want more help, then post your (relevant) database table structure here. Regards, Leo

>> add a comment
Leo Muller
11/19/2009 1:11:00 AM