we have table A and Table B, i created Table B interactive Grid to , i want to fetch record from Table A into Interactive gride which is connected with Table B. Please guide.
You need to write a SQL query that fetches data from Table A and joins it with Table B. The exact query depends on the structure of your tables and the relationship between them. Here’s an example SQL query structure: SELECT a.column1, a.column2, b.column3 FROM TableA a JOIN TableB b ON a.joinKey = b.joinKey WHERE [your conditions if any] Replace column1, column2, column3, TableA, TableB, and joinKey with the actual column names and table names from your database schema. The join Key is the column that relates Table A and Table B.
Thanks for the wonderful introduction of Shared Components
It's my pleasure
we have table A and Table B, i created Table B interactive Grid to , i want to fetch record from Table A into Interactive gride which is connected with Table B. Please guide.
You need to write a SQL query that fetches data from Table A and joins it with Table B. The exact query depends on the structure of your tables and the relationship between them.
Here’s an example SQL query structure:
SELECT a.column1, a.column2, b.column3
FROM TableA a
JOIN TableB b ON a.joinKey = b.joinKey
WHERE [your conditions if any]
Replace column1, column2, column3, TableA, TableB, and joinKey with the actual column names and table names from your database schema.
The join Key is the column that relates Table A and Table B.