MySQL Query Please Help

[huskyfritz]

---

Hello istoryans, pde ko patabang sa ako problema sa MySql query ky basic pa lng ako nabal-an so di p kau ko hanas sa databases. Dghan nko way gibuhat kaso wla ghapon kya mg-ask n lng ko s mga experts dra. (No worries, wla ko gapa-spoonfeed ky ginatry ko ako best og galearn)

May 2 tables ko naming Transaction and Guard.
Mao ni ila structure:

Transaction table
cTransNo PK char(5)
dDateStart date
dDateEnd date
lnDiscon decimal(1,0)

Guard Table
cEmpID char(5)
dDateStart date
dDateEnd date

Transaction table data
001
2011-10-10
2011-10-15
0

Guard Table data
12345
2011-10-05
2011-10-13

So ang output sa query dpat 2011-10 -10 - 2011-10-13.(bale kuhaon lng 2ng effectivity sa guard dpende sa transaction dDateStart and dDateEnd and guard dDateStart and dDateEnd)

any help will be much appreciated!

Thanks mga masters!

[salbahis]

are trying to join the data?

[Klave]

select concat(min(transaction.dDateStart), '-' , min(guard.dDateStart)) from transaction, guard

suwayi daw ni...la ko mysql so nagtsambatsamba ra ko.

Also masnindot tingali imong output i-table form sad nimo like your inputs.
Also delete invalid data like the 0 and 12345.

example

Transaction table data
2011-10-10
2011-10-15

Guard Table data
2011-10-05
2011-10-13

Output
2011-10 -10 - 2011-10-13

[spaghetti.girl]

try daw ni...using php

<?php
$query = "Select Transaction.dDateStart,Guard.dDateEnd from Transaction,Guard";
$result=mysql_query($query) or die('Invalid query'.mysql_error());

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
echo $row['dDateStart']."-".$row['dDateEnd'];
}
?>

[giovanni_elsie]

..ana lang bro imu untang ge foreign key ung transaction id sa guard nga table bale did2 nya tawakon ang inyang information .. dle paka mag libog ana.