Hello there.
First of all I must say that I am a newbie when it comes to MySQL.
Here is my problem.
I need JOIN the tbl_flight
with tbl_flight_name
for this output:
mysql> SELECT
b.myFlight,
a.myArea,
a.myFlightName,
IF(
char_length(a.myArea)<= 4,
b.myFlight,
concat(
b.myFlightArea,
'-',
a.myFlightName
)
) output
FROM
tbl_flight a
JOIN tbl_flight_name b ON a.myArea = b.myFlight;
+----------+------------+--------------------------+-------------------------------+
| myFlight | myArea | myFlightName | output |
+----------+------------+--------------------------+-------------------------------+
| XY5QU1 | XY5QU1 | UO PT | XY5Q-UO PT |
| WZ7M | WZ7M | ZN CT | WZ7M |
| WZ7M | WZ7M | ZN CT | WZ7M |
+----------+------------+--------------------------+-------------------------------+
5 rows in set
But I need this other output when show the myFlightName
in output:
+----------+------------+--------------------------+-------------------------------+
| myFlight | myArea | myFlightName | output |
+----------+------------+--------------------------+-------------------------------+
| XY5QU1 | XY5QU1 | UO PT | XY5Q-UO PT |
| WZ7M | WZ7M | ZN CT | ZN CT |
| WZ7M | WZ7M | ZN CT | ZN CT |
+----------+------------+--------------------------+-------------------------------+
Can you help me?
Thank you very much in advance.
Cheers.
You mean this?
SELECT
b.myFlight,
a.myArea,
a.myFlightName,
IF(
char_length(a.myArea)<= 4,
[B][COLOR="#FF0000"]b.myFlightName[/COLOR][/B],
concat(
b.myFlightArea,
'-',
a.myFlightName
)
) output
FROM tbl_flight a
INNER JOIN tbl_flight_name b
ON a.myArea = b.myFlight;
Hello.
Thank you for reply. Your suggestion working.
Good bye.
I’m sorry guido2004, I have new problem with your query.
mysql> SELECT
b.myFlight,
a.myArea,
a.myFlightName,
IF(
char_length(a.myArea)<= 4,
b.myFlightName,
concat(
b.myFlightArea,
'-',
a.myFlightName
)
) output
FROM tbl_flight a
INNER JOIN tbl_flight_name b
ON a.myArea = b.myFlight;
+----------+------------+--------------------------+-------------------------------+
| myFlight | myArea | myFlightName | output |
+----------+------------+--------------------------+-------------------------------+
| XY5QU1 | XY5QU1 | UO PT | XY5Q-UO PT |
| WZ7M | WZ7M | ZN CT | ZN CT |
| WZ7M | WZ7M | ZN CT | ZN CT |
+----------+------------+--------------------------+-------------------------------+
I need this different output, can you help me?
+----------+------------+--------------------------+-------------------------------+
| myFlight | myArea | myFlightName | output |
+----------+------------+--------------------------+-------------------------------+
| XY5QU1 | XY5QU1 | UO PT | ZN CT-UO PT |
| WZ7M | WZ7M | ZN CT | ZN CT |
| WZ7M | WZ7M | ZN CT | ZN CT |
+----------+------------+--------------------------+-------------------------------+
Hello there.
First of all I must say that I am a newbie when it comes to MySQL.
Here is my problem.
I need JOIN the tbl_flight
with tbl_flight_name
for this output:
mysql> SELECT
TRIM(
SUBSTRING_INDEX(output, '-', 1)
)`myFlightZone`,
TRIM(
SUBSTRING_INDEX(output, '-', - 1)
)`myFlightArea`,
output,
myFlight
FROM
(
SELECT
CASE
WHEN a. myFlightZone = 'XY5Q' THEN
'ZwNq PtS9'
END myFlight,
IF(
char_length(a.siglaunita)<= 4,
a.myFlightAreaName,
trim(
concat(
a.myFlight,
'-',
a.myFlightAreaName
)
)
)`output`
FROM
tbl_flight a
JOIN tbl_flight_name b ON a.myFlightAreaName = b.myFlightAreaName
)q;
+---------------+---------------+----------------+-----------+
| myFlightZone | myFlightArea | output | myFlight |
+---------------+---------------+----------------+-----------+
| XY5Q | UO TP123 | XY5Q-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | XY5Q-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | XY5Q-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | XY5Q-UO TP123 | ZwNq PtS9 |
+---------------+---------------+----------------+-----------+
4 rows in set
But the CASE WHEN condition not working because I need this other output:
+------------------+--------------------+--------------------+-----------+
| myFlightZone | myFlightArea | output | myFlight |
+------------------+--------------------+--------------------+-----------+
| XY5Q | UO TP123 | ZwNq PtS9-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | ZwNq PtS9-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | ZwNq PtS9-UO TP123 | ZwNq PtS9 |
| XY5Q | UO TP123 | ZwNq PtS9-UO TP123 | ZwNq PtS9 |
+------------------+--------------------+--------------------+-----------+
I need
CONCAT(myFlight,'-',myFlightArea)
Your help would be very appreciated.
thanks for your time and hints.
Cheers