MySQL Forums
Forum List  »  Views

SELECT LIMIT
Posted by: malfi syahrin
Date: May 30, 2011 04:21AM

I Have 2 Table
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
3 | 1 | 300
4 | 1 | 400
5 | 1 | 500
6 | 1 | 600
7 | 1 | 700
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300
11 | 2 | 400
12 | 2 | 500

tb_dua
LOGIN | BATAS
============
1 | 2
2 | 3

if I want to make a "VIEW" with the following structure
tb_result
ID | LOGIN | NILAI
============
1 | 1 | 100
2 | 1 | 200
8 | 2 | 100
9 | 2 | 200
10 | 2 | 300

how coding to "create a view"

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT LIMIT
3965
May 30, 2011 04:21AM
1258
June 04, 2011 03:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.