| joshnosh 2005-10-15, 6:56 pm |
| I have two tables tblLogin and tblTrades
I have 3 fields in each table, for thr purpose of this question
tblLogin Fields are
MemberNo
RegNo
Country
tblTrades fields are
MemberNo
RegNo
Country
There are other fields in both table but the fields shown are fields i
need to work on
the Tables look like this
tblLogin
----------------------------
MemberNo | RegNo | Country |
----------------------------
1 1 Wales
2 1 england
3 1 scotland
4 2 wales
5 2 england
6 2 scotland
7 3 Wales
8 3 england
9 3 scotland
10 4 wales
11 4 england
12 4 scotland
tblTrades
----------------------------
MemberNo | RegNo | Country |
----------------------------
0 1 Wales
0 1 england
0 1 scotland
0 2 wales
0 2 england
0 2 scotland
0 3 Wales
0 3 england
0 3 scotland
0 4 wales
0 4 england
0 4 scotland
I need the field MemberNo in tblTrades to match the MemberNo in
tblLogin
Any help appriciated as cant to get any SQL code i use to work,
because it must be wrong.
and its a lot of quesswork.
I am using phpMyAdmin on a MYSql database
|