|
| |
|
|
s2bn1
Posts: 192
Joined: 2/2/2002
From: Dubai United Arab Emirates
Status: offline
 |
linking two tables - 10/25/2003 14:02:49
Hi guys
I got 2 tables one with the name,location,area of some shopping malls and the 2nd one is with the shops of the malls with the items,sale status price now,price before,name of the shop.In both the tables name of the mall is there and it is the key which links both the tables.Now I want to bring the shops and malls having sale.In this page I want the name of the mall should appear only once and I used the following SQL,
Select distinct mall.mall_name,mall.area,items.shop_name,items.item_name from mall,items where items.mall_name=mall.mall_name and items.sale_status='sale'
but the malls are comming recurring.What is the mistake in this.Please help me.
Thankyou in advance
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
