Query returns multiple duplicate results

See more:

VB

MySQL

SELECT State_Mast.Name as state, Led_Grp.Name as ledger From State_Mast, Led_Grp

when I execute above query i get a output table with fields state and ledger in which
data is repeated several times .

for eg
state_mast.name has a entry say "XYZ" and ledger.name has entries "123" "456"

the output should be a table with fields state and ledger, with state having only 1 entry "XYZ" and ledger having 2 entries "123","456".
Instead I am getting a table having fields state and ledger with state having entries "XYZ" repeated several times and ledger having entries "123","456" repeated several times

What I have tried:

Nothing much, there is no relation between the two tables. I just need records from fields of two different table in on table.