display two table

Hey you should do join using ID_DATA_AGENDA(primerykey) column of DATA_AGENDA table with ID_DATA_AGENDA(forignkey) column of DATA_AGENDA_DISPOSISI_KAPUS table try yourself to write so you will learn

0

Sourav Mukherjee7y ago

SELECT a.*, b.*
FROM tbl_agenda a

INNER JOIN tbl_agenda b

ON a.primary_key_column = b.primary_key_column

0

Mega Anaska7y ago

I want to display values that have agenda data. Field = 'b' and data_agenda. field = 'c' and they have a value in DATA_AGENDA_DISPOSISI_KAPUS.disposisi = 'va'

0

Madan Shekar7y ago

please give me columns and all

0