Concatenate

[Alex Motilal]

Hello friends,


I have a Database of Cotton Ginning & Pressing operations. Among the tables, two tables are:

tblLots with LotID, LotNumber, NumberOfBales as fields
tblPressing with Lot_ID, BalesPressed, DtOfPressing and the relation is set to LotID/Lot_ID

The number of bales for each Lot will be 100. However, pressing dates may vary. For example LotID 1 may be pressed on two different dates such as 48 bales on 24/07/2017 and 52 bales on 25/07/2017.

I want a query with fields LotID, PressingDtAndBales and the following as result:

1 48:24/07/2017;52:25/07/2017

The second field result is concatenated.

Please give the SQL for the concatenation.

Thanks

[June7]

Cannot do this with SQL alone.

Review: http://allenbrowne.com/func-concat.html

[orange]

I agree with June. Allen Browne's function is often referenced for this type of presentation.
Are there more tables in your database/business? If so, where do they fit?