Problem with join syntax

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&gt; 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)&lt;= 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