i wanted to write a query, or a view to be exact to display data from two tables as follow:
1. schedule_table (scheduleID as pk)
2. remarks (remarkID as pk, scheduleID as fk)
meaning a schedule can contain many many remarks and non at all.
now the problem is i want to display the data in one line. for example:
1. scheduleID remark1, remark2, remark3, remark4.
2. scheduleID remark1, remark2
how do i go about doing this?