I would like to ask Mysql different fields have different records to return, how to query if you want to put them together?

Kotlin
IOS
VB.Net
SQL
Node.js
Swift
Ruby
Go
Oracle
Git
Laravel
Mongodb
Asp.Net
More...

A table field has 3 records returned by separate query
B table field alone query has 8 records returned
currently these two tables have no primary key and foreign key
if you want to combine, how should the structure of the table be designed and how should the model be built

Sql mysql python

Jun.05,2022

select a as a1,b as a2 ,c as a3 from t1 where xx=xx
union 
select b1 as a1,b2 as a2 ,b3 as a3 from t1 where xx=xx

Previous: How is Zhihu's database designed?

Next: How to store and query data with multiple sets of attributes?

False
Django, Why does the system automatically generate an empty session? every time the request is made?
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
How to self-start the php-fpm service when building a LNMP environment with docker?
Can an array in react state be bound to a dom state using an element in the array?
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
In express+hbs, how do you define the routed data as a variable on the page?
How to use symbol reference of Iconfont in dva
How to elegantly add data to JSON objects?
Using node to build video streaming server
The proportional width of the echarts graph is inconsistent.
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
I don't understand what a linux command means. Please explain it.
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
Running nodejs reports fewer errors ")"

How do I perform the action of a specified event before the page binding is refreshed?
Define a global variable that automatically transforms the value
How exactly does CoreData lightweight migration work?
Why is the test in {test () {}} recognized as a function?
WeChat Mini Programs's template and component usage scene