joinning three table with same column name

Vote count:

0

select opposition.Op_Ldr_Name,opposition.Op_Ldr_begin,date_format(opposition.Op_Ldr_begin,'%m,%D %w,%Y') AS "date of election" FROM ((opposition inner join deputy_pm on opposition.party = deputy_pm.party) inner join ministry on deputy_pm.party = ministry.party) where ((opposition.party <> 'National Labor') and opposition.Op_Ldr_begin > '1980-01-01')

thesesult shows 1000 rows any one can help me

asked 9 secs ago

user3667446

1

joinning three table with same column name