Display Query [message #580697] |
Wed, 27 March 2013 01:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c86fedf38fdae46febdd4144bf66e65d?s=64&d=mm&r=g) |
furqan
Messages: 115 Registered: January 2012 Location: Hyderabad
|
Senior Member |
|
|
hello sir..
want to display records of two tables in in one form.
I have 2 tables. tab1 and tab2
columns in tab1 are code, desc, part, onhand_qty AND
columns in tab2 are code, room_no, row_no, rack, shelf, qty, remarks.
Common column in both the tables is code.
i want to display all the columns of both the tables where tab1.code=tab2.code ,
and tab1.onhand_qty is not equal to SUM of tab2.qty
help please...
Thanks in Advance.
|
|
|
Re: Display Query [message #580706 is a reply to message #580697] |
Wed, 27 March 2013 02:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Create a view; its WHERE clause will contain conditions you mentioned. Then, create a form based on that view.
|
|
|